2024-11-05 18:22:49,807 [ 611864 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse (runner:42, check_args_and_update_paths) 2024-11-05 18:22:49,807 [ 611864 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:86, check_args_and_update_paths) 2024-11-05 18:22:49,808 [ 611864 ] INFO : utils dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/utils (runner:97, check_args_and_update_paths) 2024-11-05 18:22:49,808 [ 611864 ] INFO : base_configs_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:99, check_args_and_update_paths) clickhouse_integration_tests_volume Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_rydkld --privileged --dns-search='.' --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=2cffe1eae894 -e DOCKER_BASE_TAG=1d1c87eee2db -e DOCKER_KERBERIZED_HADOOP_TAG=ce74919e88f5 -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=a2d3dc777d0c -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS=" -rfEps --run-id=2 --color=no --durations=0 test_postgresql_replica_database_engine_2/test.py::test_quoting_publication -vvv" altinityinfra/integration-tests-runner:9d492c2eec24 '. Start tests ============================= test session starts ============================== platform linux -- Python 3.10.12, pytest-7.4.4, pluggy-1.5.0 -- /usr/bin/python3 cachedir: .pytest_cache rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: repeat-0.9.3, reportlog-0.4.0, random-0.2, timeout-2.2.0, order-1.0.1, xdist-3.5.0 timeout: 900.0s timeout method: signal timeout func_only: False collecting ... collected 1 item test_postgresql_replica_database_engine_2/test.py::test_quoting_publication FAILED [100%] =================================== FAILURES =================================== ___________________________ test_quoting_publication ___________________________ started_cluster = def test_quoting_publication(started_cluster): postgres_database = "postgres-postgres" pg_manager3 = PostgresManager() pg_manager3.init( instance, cluster.postgres_ip, cluster.postgres_port, default_database=postgres_database, ) NUM_TABLES = 5 materialized_database = "test-database" pg_manager3.create_and_fill_postgres_tables(NUM_TABLES, 10000) check_table_name_1 = "postgresql-replica-5" pg_manager3.create_and_fill_postgres_table(check_table_name_1) > pg_manager3.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, materialized_database=materialized_database, ) test_postgresql_replica_database_engine_2/test.py:1117: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:248: in create_materialized_db self.instance.query(f"DROP DATABASE IF EXISTS {materialized_database}") helpers/cluster.py:3451: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 62, stderr: Code: 62. DB::Exception: Syntax error: failed at position 29 ('-'): -database. Expected one of: ON, NO DELAY, SYNC, INTO OUTFILE, FORMAT, SETTINGS, end of query. (SYNTAX_ERROR), Stack trace (when copying this message, always include the lines below): E E 0. DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000c8aafdb E 1. DB::Exception::createDeprecated(String const&, int, bool) @ 0x000000000c90726d E 2. DB::parseQueryAndMovePosition(DB::IParser&, char const*&, char const*, String const&, bool, unsigned long, unsigned long, unsigned long) @ 0x0000000012908b2a E 3. DB::ClientBase::parseQuery(char const*&, char const*, bool) const @ 0x0000000011f09122 E 4. DB::ClientBase::executeMultiQuery(String const&) @ 0x0000000011f19a4f E 5. DB::ClientBase::processQueryText(String const&) @ 0x0000000011f1ae90 E 6. DB::ClientBase::runNonInteractive() @ 0x0000000011f1fcd3 E 7. DB::Client::main(std::vector> const&) @ 0x000000000caba05f E 8. Poco::Util::Application::run() @ 0x00000000149a4266 E 9. mainEntryClickHouseClient(int, char**) @ 0x000000000cacc4a8 E 10. main @ 0x0000000007661498 E 11. ? @ 0x00007f351d7ead90 E 12. ? @ 0x00007f351d7eae40 E 13. _start @ 0x0000000005df212e helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- Copy common default production configuration from /clickhouse-config. Files: config.xml, users.xml Copy common default production configuration from /clickhouse-config. Files: config.xml, users.xml PostgreSQL is available - running test ------------------------------ Captured log setup ------------------------------ 2024-11-05 18:22:52 [ 506 ] DEBUG : Command:['docker ps | wc -l'] (cluster.py:109, run_and_check) 2024-11-05 18:22:52 [ 506 ] DEBUG : Stdout:1 (cluster.py:117, run_and_check) 2024-11-05 18:22:52 [ 506 ] DEBUG : No running containers (conftest.py:92, cleanup_environment) 2024-11-05 18:22:52 [ 506 ] DEBUG : Pruning Docker networks (conftest.py:94, cleanup_environment) 2024-11-05 18:22:52 [ 506 ] DEBUG : Command:['docker network prune --force'] (cluster.py:109, run_and_check) 2024-11-05 18:22:52 [ 506 ] DEBUG : Command:["sysctl net.ipv4.ip_local_port_range='55000 65535'"] (cluster.py:109, run_and_check) 2024-11-05 18:22:52 [ 506 ] DEBUG : Stdout:net.ipv4.ip_local_port_range = 55000 65535 (cluster.py:117, run_and_check) 2024-11-05 18:22:52 [ 506 ] INFO : Running tests in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/test.py (cluster.py:2658, start) 2024-11-05 18:22:52 [ 506 ] DEBUG : Cluster start called. is_up=False (cluster.py:2665, start) 2024-11-05 18:22:52 [ 506 ] DEBUG : Docker networks for project roottestpostgresqlreplicadatabaseengine2 are NETWORK ID NAME DRIVER SCOPE (cluster.py:776, print_all_docker_pieces) 2024-11-05 18:22:52 [ 506 ] DEBUG : Docker containers for project roottestpostgresqlreplicadatabaseengine2 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:784, print_all_docker_pieces) 2024-11-05 18:22:52 [ 506 ] DEBUG : Docker volumes for project roottestpostgresqlreplicadatabaseengine2 are DRIVER VOLUME NAME (cluster.py:792, print_all_docker_pieces) 2024-11-05 18:22:52 [ 506 ] DEBUG : Cleanup called (cluster.py:797, cleanup) 2024-11-05 18:22:52 [ 506 ] DEBUG : Docker networks for project roottestpostgresqlreplicadatabaseengine2 are NETWORK ID NAME DRIVER SCOPE (cluster.py:776, print_all_docker_pieces) 2024-11-05 18:22:52 [ 506 ] DEBUG : Docker containers for project roottestpostgresqlreplicadatabaseengine2 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:784, print_all_docker_pieces) 2024-11-05 18:22:52 [ 506 ] DEBUG : Docker volumes for project roottestpostgresqlreplicadatabaseengine2 are DRIVER VOLUME NAME (cluster.py:792, print_all_docker_pieces) 2024-11-05 18:22:52 [ 506 ] DEBUG : Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine2_.*_1$' --format '{{.ID}}:{{.Names}}' (cluster.py:109, run_and_check) 2024-11-05 18:22:52 [ 506 ] DEBUG : Unstopped containers: {} (cluster.py:811, cleanup) 2024-11-05 18:22:52 [ 506 ] DEBUG : No running containers for project: roottestpostgresqlreplicadatabaseengine2 (cluster.py:825, cleanup) 2024-11-05 18:22:52 [ 506 ] DEBUG : Trying to prune unused networks... (cluster.py:831, cleanup) 2024-11-05 18:22:52 [ 506 ] DEBUG : Trying to prune unused images... (cluster.py:847, cleanup) 2024-11-05 18:22:52 [ 506 ] DEBUG : Command:['docker', 'image', 'prune', '-f'] (cluster.py:109, run_and_check) 2024-11-05 18:22:52 [ 506 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:117, run_and_check) 2024-11-05 18:22:52 [ 506 ] DEBUG : Images pruned (cluster.py:850, cleanup) 2024-11-05 18:22:52 [ 506 ] DEBUG : Trying to prune unused volumes... (cluster.py:856, cleanup) 2024-11-05 18:22:52 [ 506 ] DEBUG : Command:['docker volume ls | wc -l'] (cluster.py:109, run_and_check) 2024-11-05 18:22:52 [ 506 ] DEBUG : Stdout:1 (cluster.py:117, run_and_check) 2024-11-05 18:22:52 [ 506 ] DEBUG : Setup directory for instance: instance (cluster.py:2678, start) 2024-11-05 18:22:52 [ 506 ] DEBUG : Create directory for configuration generated in this helper (cluster.py:4378, create_dir) 2024-11-05 18:22:52 [ 506 ] DEBUG : Create directory for common tests configuration (cluster.py:4383, create_dir) 2024-11-05 18:22:52 [ 506 ] DEBUG : Copy common configuration from helpers (cluster.py:4403, create_dir) 2024-11-05 18:22:52 [ 506 ] DEBUG : Generate and write macros file (cluster.py:4436, create_dir) 2024-11-05 18:22:52 [ 506 ] DEBUG : Copy custom test config files ['/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/configs/log_conf.xml'] to /ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance/configs/config.d (cluster.py:4466, create_dir) 2024-11-05 18:22:52 [ 506 ] DEBUG : Setup database dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance/database (cluster.py:4483, create_dir) 2024-11-05 18:22:52 [ 506 ] DEBUG : Setup logs dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance/logs (cluster.py:4494, create_dir) 2024-11-05 18:22:52 [ 506 ] DEBUG : Entrypoint cmd: bash -c "trap 'pkill tail' INT TERM; clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon; coproc tail -f /dev/null; wait $$!" (cluster.py:4579, create_dir) 2024-11-05 18:22:52 [ 506 ] DEBUG : Setup directory for instance: instance2 (cluster.py:2678, start) 2024-11-05 18:22:52 [ 506 ] DEBUG : Create directory for configuration generated in this helper (cluster.py:4378, create_dir) 2024-11-05 18:22:52 [ 506 ] DEBUG : Create directory for common tests configuration (cluster.py:4383, create_dir) 2024-11-05 18:22:52 [ 506 ] DEBUG : Copy common configuration from helpers (cluster.py:4403, create_dir) 2024-11-05 18:22:52 [ 506 ] DEBUG : Generate and write macros file (cluster.py:4436, create_dir) 2024-11-05 18:22:52 [ 506 ] DEBUG : Copy custom test config files ['/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/configs/log_conf.xml', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/configs/merge_tree_too_many_parts.xml'] to /ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance2/configs/config.d (cluster.py:4466, create_dir) 2024-11-05 18:22:52 [ 506 ] DEBUG : Setup database dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance2/database (cluster.py:4483, create_dir) 2024-11-05 18:22:52 [ 506 ] DEBUG : Setup logs dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance2/logs (cluster.py:4494, create_dir) 2024-11-05 18:22:52 [ 506 ] DEBUG : Entrypoint cmd: bash -c "trap 'pkill tail' INT TERM; clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon; coproc tail -f /dev/null; wait $$!" (cluster.py:4579, create_dir) 2024-11-05 18:22:52 [ 506 ] DEBUG : Env {'ASAN_OPTIONS': 'use_sigaltstack=0', 'TSAN_OPTIONS': 'use_sigaltstack=0', 'CLICKHOUSE_WATCHDOG_ENABLE': '0', 'CLICKHOUSE_NATS_TLS_SECURE': '0', 'LLVM_PROFILE_FILE': '/var/lib/clickhouse/server_%h_%p_%m.profraw', 'POSTGRES_PORT': '5432', 'POSTGRES_DIR': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/postgres/postgres1', 'POSTGRES_LOGS_FS': 'bind'} stored in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/.env (cluster.py:82, _create_env_file) 2024-11-05 18:22:52 [ 506 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2024-11-05 18:22:52 [ 506 ] DEBUG : No config file found (config.py:28, find_config_file) 2024-11-05 18:22:52 [ 506 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2024-11-05 18:22:52 [ 506 ] DEBUG : No config file found (config.py:28, find_config_file) 2024-11-05 18:22:52 [ 506 ] DEBUG : http://localhost:None "GET /version HTTP/1.1" 200 826 (connectionpool.py:546, _make_request) 2024-11-05 18:22:52 [ 506 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine2', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance2/docker-compose.yml', 'pull'] (cluster.py:109, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:Pulling instance2 ... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:Pulling postgres1 ... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:Pulling instance ... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:Pulling instance2 ... pulling from altinityinfra/integr... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:Pulling instance2 ... digest: sha256:528fcf9f160536c036... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:Pulling instance2 ... status: image is up to date for a... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:Pulling instance2 ... done (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:Pulling postgres1 ... pulling from library/postgres (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:Pulling postgres1 ... digest: sha256:8d3be35b184e70d81e... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:Pulling postgres1 ... status: image is up to date for p... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:Pulling postgres1 ... done (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:Pulling instance ... pulling from altinityinfra/integr... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:Pulling instance ... digest: sha256:528fcf9f160536c036... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:Pulling instance ... status: image is up to date for a... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:Pulling instance ... done (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Setup Postgres (cluster.py:2790, start) 2024-11-05 18:23:04 [ 506 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine2', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', '--verbose', 'up', '-d'] (cluster.py:109, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.config.config.find: Using configuration files: /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.docker_client.get_client: docker-compose version 1.29.2, build unknown (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:docker-py version: (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:CPython version: 3.10.12 (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:OpenSSL version: OpenSSL 3.0.2 15 Mar 2022 (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.docker_client.get_client: Docker base_url: http+docker://localhost (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.docker_client.get_client: Docker version: Platform={'Name': 'Docker Engine - Community'}, Components=[{'Name': 'Engine', 'Version': '23.0.6', 'Details': {'ApiVersion': '1.42', 'Arch': 'amd64', 'BuildTime': '2023-05-05T21:18:13.000000000+00:00', 'Experimental': 'false', 'GitCommit': '9dbdbd4', 'GoVersion': 'go1.19.9', 'KernelVersion': '5.15.0-122-generic', 'MinAPIVersion': '1.12', 'Os': 'linux'}}, {'Name': 'containerd', 'Version': '1.7.18', 'Details': {'GitCommit': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}}, {'Name': 'runc', 'Version': '1.7.18', 'Details': {'GitCommit': 'v1.1.13-0-g58aa920'}}, {'Name': 'docker-init', 'Version': '0.19.0', 'Details': {'GitCommit': 'de40ad0'}}], Version=23.0.6, ApiVersion=1.42, MinAPIVersion=1.12, GitCommit=9dbdbd4, GoVersion=go1.19.9, Os=linux, Arch=amd64, KernelVersion=5.15.0-122-generic, BuildTime=2023-05-05T21:18:13.000000000+00:00 (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine2_default') (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker info <- () (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker info -> {'Architecture': 'x86_64', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'BridgeNfIp6tables': True, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'BridgeNfIptables': True, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'CPUSet': True, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'CPUShares': True, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'CgroupDriver': 'cgroupfs', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'CgroupVersion': '2', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'ContainerdCommit': {'Expected': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'ID': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Containers': 0, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine2_default') (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.network.ensure: Creating network "roottestpostgresqlreplicadatabaseengine2_default" with the default driver (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network <- (name='roottestpostgresqlreplicadatabaseengine2_default', driver=None, options=None, ipam=None, internal=False, enable_ipv6=False, labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine2', 'com.docker.compose.network': 'default', 'com.docker.compose.version': '1.29.2'}, attachable=True, check_duplicate=True) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network -> {'Id': '76cb4afd2506bfd47eaec8f57648d48f8a693ad86b1b39aac74289e77c11dcd5', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Warning': ''} (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine2', 'com.docker.compose.oneoff=False']}) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine2', 'com.docker.compose.oneoff=False']}) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine2', 'com.docker.compose.oneoff=False']}) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine2', 'com.docker.compose.oneoff=False']}) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine2', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine2', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Author': '', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Comment': 'buildkit.dockerfile.v0', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Config': {'ArgsEscaped': True, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'AttachStderr': False, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'AttachStdin': False, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'AttachStdout': False, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Cmd': ['postgres'], (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Domainname': '', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Entrypoint': ['docker-entrypoint.sh'], (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine2', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine2', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: {} (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.parallel.feed_queue: Starting producer thread for (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine2', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine2', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine2_postgres1_1 ... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: {ServiceName(project='roottestpostgresqlreplicadatabaseengine2', service='postgres1', number=1)} (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.parallel.feed_queue: Starting producer thread for ServiceName(project='roottestpostgresqlreplicadatabaseengine2', service='postgres1', number=1) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Author': '', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Comment': 'buildkit.dockerfile.v0', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Config': {'ArgsEscaped': True, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'AttachStderr': False, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'AttachStdin': False, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'AttachStdout': False, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Cmd': ['postgres'], (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Domainname': '', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Entrypoint': ['docker-entrypoint.sh'], (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Author': '', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Comment': 'buildkit.dockerfile.v0', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Config': {'ArgsEscaped': True, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'AttachStderr': False, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'AttachStdin': False, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'AttachStdout': False, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Cmd': ['postgres'], (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Domainname': '', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Entrypoint': ['docker-entrypoint.sh'], (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.service.build_container_labels: Added config hash: f30fe441bf467950e4651cf0c73fdad35195f468eec0a135fd5d52406072f361 (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config <- (links=[], port_bindings={}, binds=[], volumes_from=[], privileged=False, network_mode='roottestpostgresqlreplicadatabaseengine2_default', devices=None, device_requests=None, dns=None, dns_opt=None, dns_search=None, restart_policy={'Name': 'always', 'MaximumRetryCount': 0}, runtime=None, cap_add=None, cap_drop=None, mem_limit=None, mem_reservation=None, memswap_limit=None, ulimits=None, log_config={'Type': '', 'Config': {}}, extra_hosts=None, read_only=None, pid_mode=None, security_opt=None, ipc_mode=None, cgroup_parent=None, cpu_quota=None, shm_size=None, sysctls=None, pids_limit=None, tmpfs=None, oom_kill_disable=None, oom_score_adj=None, mem_swappiness=None, group_add=None, userns_mode=None, init=None, init_path=None, isolation=None, cpu_count=None, cpu_percent=None, nano_cpus=None, volume_driver=None, cpuset_cpus=None, cpu_shares=None, storage_opt=None, blkio_weight=None, blkio_weight_device=None, device_read_bps=None, device_read_iops=None, device_write_bps=None, device_write_iops=None, mounts=[{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}], device_cgroup_rules=None, cpu_period=None, cpu_rt_period=None, cpu_rt_runtime=None) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config -> {'Binds': [], (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Links': [], (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'LogConfig': {'Config': {}, 'Type': ''}, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Mounts': [{'ReadOnly': None, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/postgres/postgres1', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Target': '/postgres/', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Type': 'bind'}], (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'NetworkMode': 'roottestpostgresqlreplicadatabaseengine2_default', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'PortBindings': {}, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'RestartPolicy': {'MaximumRetryCount': 0, 'Name': 'always'}, (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container <- (command=['postgres', '-c', 'wal_level=logical', '-c', 'max_replication_slots=4', '-c', 'logging_collector=on', '-c', 'log_directory=/postgres/logs', '-c', 'log_filename=postgresql.log', '-c', 'log_statement=all', '-c', 'max_connections=200'], environment=['POSTGRES_HOST_AUTH_METHOD=trust', 'POSTGRES_PASSWORD=mysecretpassword', 'PGDATA=/postgres/data'], healthcheck={'test': ['CMD-SHELL', 'pg_isready -U postgres'], 'interval': 10000000000, 'timeout': 5000000000, 'retries': 5}, image='postgres', volumes={}, name='roottestpostgresqlreplicadatabaseengine2_postgres1_1', detach=True, ports=['5432'], labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine2', 'com.docker.compose.service': 'postgres1', 'com.docker.compose.oneoff': 'False', 'com.docker.compose.project.working_dir': '/ClickHouse/tests/integration/compose', 'com.docker.compose.project.config_files': '/ClickHouse/tests/integration/compose/docker_compose_postgres.yml', 'com.docker.compose.project.environment_file': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/.env', 'com.docker.compose.container-number': '1', 'com.docker.compose.version': '1.29.2', 'com.docker.compose.config-hash': 'f30fe441bf467950e4651cf0c73fdad35195f468eec0a135fd5d52406072f361'}, host_config={'NetworkMode': 'roottestpostgresqlreplicadatabaseengine2_default', 'RestartPolicy': {'Name': 'always', 'MaximumRetryCount': 0}, 'VolumesFrom': [], 'Binds': [], 'PortBindings': {}, 'Links': [], 'LogConfig': {'Type': '', 'Config': {}}, 'Mounts': [{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}]}, networking_config={'EndpointsConfig': {'roottestpostgresqlreplicadatabaseengine2_default': {'Aliases': ['postgres1', 'postgre-sql.local'], 'IPAMConfig': {}}}}) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container -> {'Id': '75333eead255b16f982bba239fd90aa4906c89d26bc602a53a742b951e5b51d2', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Warnings': []} (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container <- ('75333eead255b16f982bba239fd90aa4906c89d26bc602a53a742b951e5b51d2') (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container -> {'AppArmorProfile': '', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'Args': ['postgres', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: '-c', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'wal_level=logical', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: '-c', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'max_replication_slots=4', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: '-c', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'logging_collector=on', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: '-c', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr: 'log_directory=/postgres/logs', (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:... (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network <- ('75333eead255b16f982bba239fd90aa4906c89d26bc602a53a742b951e5b51d2', 'roottestpostgresqlreplicadatabaseengine2_default') (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network -> None (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network <- ('75333eead255b16f982bba239fd90aa4906c89d26bc602a53a742b951e5b51d2', 'roottestpostgresqlreplicadatabaseengine2_default', aliases=['75333eead255', 'postgres1', 'postgre-sql.local'], ipv4_address=None, ipv6_address=None, links=[], link_local_ips=None) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network -> None (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker start <- ('75333eead255b16f982bba239fd90aa4906c89d26bc602a53a742b951e5b51d2') (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker start -> None (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.parallel.parallel_execute_iter: Finished processing: ServiceName(project='roottestpostgresqlreplicadatabaseengine2', service='postgres1', number=1) (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine2_postgres1_1 ... done (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.parallel.parallel_execute_iter: Finished processing: (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:119, run_and_check) 2024-11-05 18:23:04 [ 506 ] DEBUG : get_instance_ip instance_name=postgres1 (cluster.py:2004, get_instance_ip) 2024-11-05 18:23:04 [ 506 ] DEBUG : http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine2_postgres1_1/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2024-11-05 18:23:04 [ 506 ] DEBUG : Can't connect to Postgres connection to server at "172.16.1.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? (cluster.py:2242, wait_postgres_to_start) 2024-11-05 18:23:05 [ 506 ] DEBUG : Can't connect to Postgres connection to server at "172.16.1.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? (cluster.py:2242, wait_postgres_to_start) 2024-11-05 18:23:05 [ 506 ] DEBUG : Postgres Started (cluster.py:2239, wait_postgres_to_start) 2024-11-05 18:23:05 [ 506 ] DEBUG : ('Trying to create ClickHouse instance by command %s', 'docker-compose --env-file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/.env --project-name roottestpostgresqlreplicadatabaseengine2 --file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml --file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance2/docker-compose.yml up -d --no-recreate') (cluster.py:3001, start) 2024-11-05 18:23:05 [ 506 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine2', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance2/docker-compose.yml', 'up', '-d', '--no-recreate'] (cluster.py:109, run_and_check) 2024-11-05 18:23:06 [ 506 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine2_instance_1 ... (cluster.py:119, run_and_check) 2024-11-05 18:23:06 [ 506 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine2_instance2_1 ... (cluster.py:119, run_and_check) 2024-11-05 18:23:06 [ 506 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine2_instance2_1 ... done (cluster.py:119, run_and_check) 2024-11-05 18:23:06 [ 506 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine2_instance_1 ... done (cluster.py:119, run_and_check) 2024-11-05 18:23:06 [ 506 ] DEBUG : ClickHouse instance created (cluster.py:3009, start) 2024-11-05 18:23:06 [ 506 ] DEBUG : get_instance_ip instance_name=instance (cluster.py:2004, get_instance_ip) 2024-11-05 18:23:06 [ 506 ] DEBUG : http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine2_instance_1/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2024-11-05 18:23:06 [ 506 ] DEBUG : Waiting for ClickHouse start in instance, ip: 172.16.1.4... (cluster.py:3016, start) 2024-11-05 18:23:06 [ 506 ] DEBUG : http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine2_instance_1/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2024-11-05 18:23:06 [ 506 ] DEBUG : http://localhost:None "GET /v1.42/containers/388d202474585977b33dee1e205a1d18811b9dc650eab6d814b47a8133c5c187/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2024-11-05 18:23:07 [ 506 ] DEBUG : http://localhost:None "GET /v1.42/containers/388d202474585977b33dee1e205a1d18811b9dc650eab6d814b47a8133c5c187/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2024-11-05 18:23:07 [ 506 ] DEBUG : http://localhost:None "GET /v1.42/containers/388d202474585977b33dee1e205a1d18811b9dc650eab6d814b47a8133c5c187/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2024-11-05 18:23:07 [ 506 ] DEBUG : http://localhost:None "GET /v1.42/containers/388d202474585977b33dee1e205a1d18811b9dc650eab6d814b47a8133c5c187/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2024-11-05 18:23:07 [ 506 ] DEBUG : ClickHouse instance started (cluster.py:3020, start) 2024-11-05 18:23:07 [ 506 ] DEBUG : get_instance_ip instance_name=instance2 (cluster.py:2004, get_instance_ip) 2024-11-05 18:23:07 [ 506 ] DEBUG : http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine2_instance2_1/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2024-11-05 18:23:07 [ 506 ] DEBUG : Waiting for ClickHouse start in instance2, ip: 172.16.1.3... (cluster.py:3016, start) 2024-11-05 18:23:07 [ 506 ] DEBUG : http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine2_instance2_1/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2024-11-05 18:23:07 [ 506 ] DEBUG : http://localhost:None "GET /v1.42/containers/3ca9b9718544d9b81a767824cd5036709b543e2b188e1f359caa08ae9cb0fbe3/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2024-11-05 18:23:07 [ 506 ] DEBUG : ClickHouse instance2 started (cluster.py:3020, start) 2024-11-05 18:23:07 [ 506 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3450, query) 2024-11-05 18:23:07 [ 506 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.1.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3450, query) 2024-11-05 18:23:07 [ 506 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance2 (cluster.py:3450, query) 2024-11-05 18:23:07 [ 506 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.1.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance2 (cluster.py:3450, query) 2024-11-05 18:23:07 [ 506 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database2" on instance2 (cluster.py:3450, query) 2024-11-05 18:23:07 [ 506 ] DEBUG : Executing query CREATE DATABASE "postgres_database2" ENGINE = PostgreSQL('172.16.1.2:5432', 'postgres_database2', 'postgres', 'mysecretpassword') on instance2 (cluster.py:3450, query) 2024-11-05 18:23:07 [ 506 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres-postgres" on instance (cluster.py:3450, query) 2024-11-05 18:23:07 [ 506 ] DEBUG : Executing query CREATE DATABASE "postgres-postgres" ENGINE = PostgreSQL('172.16.1.2:5432', 'postgres-postgres', 'postgres', 'mysecretpassword') on instance (cluster.py:3450, query) ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_1" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_2" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_3" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_4" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql-replica-5" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) ------------------------------ Captured log call ------------------------------- 2024-11-05 18:23:07 [ 506 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres-postgres" on instance (cluster.py:3450, query) 2024-11-05 18:23:07 [ 506 ] DEBUG : Executing query CREATE DATABASE "postgres-postgres" ENGINE = PostgreSQL('172.16.1.2:5432', 'postgres-postgres', 'postgres', 'mysecretpassword') on instance (cluster.py:3450, query) 2024-11-05 18:23:07 [ 506 ] DEBUG : Executing query INSERT INTO `postgres-postgres`.postgresql_replica_0 SELECT number, number from numbers(10000) on instance (cluster.py:3450, query) 2024-11-05 18:23:08 [ 506 ] DEBUG : Executing query INSERT INTO `postgres-postgres`.postgresql_replica_1 SELECT number, number from numbers(10000) on instance (cluster.py:3450, query) 2024-11-05 18:23:08 [ 506 ] DEBUG : Executing query INSERT INTO `postgres-postgres`.postgresql_replica_2 SELECT number, number from numbers(10000) on instance (cluster.py:3450, query) 2024-11-05 18:23:08 [ 506 ] DEBUG : Executing query INSERT INTO `postgres-postgres`.postgresql_replica_3 SELECT number, number from numbers(10000) on instance (cluster.py:3450, query) 2024-11-05 18:23:08 [ 506 ] DEBUG : Executing query INSERT INTO `postgres-postgres`.postgresql_replica_4 SELECT number, number from numbers(10000) on instance (cluster.py:3450, query) 2024-11-05 18:23:08 [ 506 ] DEBUG : Executing query INSERT INTO `postgres-postgres`.`postgresql-replica-5` SELECT number, number from numbers(50) on instance (cluster.py:3450, query) 2024-11-05 18:23:08 [ 506 ] DEBUG : Executing query DROP DATABASE IF EXISTS test-database on instance (cluster.py:3450, query) ---------------------------- Captured log teardown ----------------------------- 2024-11-05 18:23:08 [ 506 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3450, query) 2024-11-05 18:23:09 [ 506 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3450, query) 2024-11-05 18:23:09 [ 506 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.1.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3450, query) 2024-11-05 18:23:09 [ 506 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine2', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance2/docker-compose.yml', 'stop', '--timeout', '20'] (cluster.py:109, run_and_check) 2024-11-05 18:23:10 [ 506 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine2_instance2_1 ... (cluster.py:119, run_and_check) 2024-11-05 18:23:10 [ 506 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine2_instance_1 ... (cluster.py:119, run_and_check) 2024-11-05 18:23:10 [ 506 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine2_postgres1_1 ... (cluster.py:119, run_and_check) 2024-11-05 18:23:10 [ 506 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine2_postgres1_1 ... done (cluster.py:119, run_and_check) 2024-11-05 18:23:10 [ 506 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine2_instance_1 ... done (cluster.py:119, run_and_check) 2024-11-05 18:23:10 [ 506 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine2_instance2_1 ... done (cluster.py:119, run_and_check) 2024-11-05 18:23:10 [ 506 ] DEBUG : Command:['bash', '-c', '[ -f /ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance/logs/stderr.log* || true'] (cluster.py:109, run_and_check) 2024-11-05 18:23:10 [ 506 ] DEBUG : Command:['bash', '-c', '[ -f /ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance2/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance2/logs/stderr.log* || true'] (cluster.py:109, run_and_check) 2024-11-05 18:23:10 [ 506 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine2', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_2/_instances_2/instance2/docker-compose.yml', 'down', '--volumes'] (cluster.py:109, run_and_check) 2024-11-05 18:23:11 [ 506 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine2_instance2_1 ... (cluster.py:119, run_and_check) 2024-11-05 18:23:11 [ 506 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine2_instance_1 ... (cluster.py:119, run_and_check) 2024-11-05 18:23:11 [ 506 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine2_postgres1_1 ... (cluster.py:119, run_and_check) 2024-11-05 18:23:11 [ 506 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine2_postgres1_1 ... done (cluster.py:119, run_and_check) 2024-11-05 18:23:11 [ 506 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine2_instance_1 ... done (cluster.py:119, run_and_check) 2024-11-05 18:23:11 [ 506 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine2_instance2_1 ... done (cluster.py:119, run_and_check) 2024-11-05 18:23:11 [ 506 ] DEBUG : Stderr:Removing network roottestpostgresqlreplicadatabaseengine2_default (cluster.py:119, run_and_check) 2024-11-05 18:23:11 [ 506 ] DEBUG : Cleanup called (cluster.py:797, cleanup) 2024-11-05 18:23:11 [ 506 ] DEBUG : Docker networks for project roottestpostgresqlreplicadatabaseengine2 are NETWORK ID NAME DRIVER SCOPE (cluster.py:776, print_all_docker_pieces) 2024-11-05 18:23:11 [ 506 ] DEBUG : Docker containers for project roottestpostgresqlreplicadatabaseengine2 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:784, print_all_docker_pieces) 2024-11-05 18:23:11 [ 506 ] DEBUG : Docker volumes for project roottestpostgresqlreplicadatabaseengine2 are DRIVER VOLUME NAME (cluster.py:792, print_all_docker_pieces) 2024-11-05 18:23:11 [ 506 ] DEBUG : Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine2_.*_1$' --format '{{.ID}}:{{.Names}}' (cluster.py:109, run_and_check) 2024-11-05 18:23:11 [ 506 ] DEBUG : Unstopped containers: {} (cluster.py:811, cleanup) 2024-11-05 18:23:11 [ 506 ] DEBUG : No running containers for project: roottestpostgresqlreplicadatabaseengine2 (cluster.py:825, cleanup) 2024-11-05 18:23:11 [ 506 ] DEBUG : Trying to prune unused networks... (cluster.py:831, cleanup) 2024-11-05 18:23:11 [ 506 ] DEBUG : Trying to prune unused images... (cluster.py:847, cleanup) 2024-11-05 18:23:11 [ 506 ] DEBUG : Command:['docker', 'image', 'prune', '-f'] (cluster.py:109, run_and_check) 2024-11-05 18:23:11 [ 506 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:117, run_and_check) 2024-11-05 18:23:11 [ 506 ] DEBUG : Images pruned (cluster.py:850, cleanup) 2024-11-05 18:23:11 [ 506 ] DEBUG : Trying to prune unused volumes... (cluster.py:856, cleanup) 2024-11-05 18:23:11 [ 506 ] DEBUG : Command:['docker volume ls | wc -l'] (cluster.py:109, run_and_check) 2024-11-05 18:23:11 [ 506 ] DEBUG : Stdout:1 (cluster.py:117, run_and_check) ============================== slowest durations =============================== 15.10s setup test_postgresql_replica_database_engine_2/test.py::test_quoting_publication 2.43s teardown test_postgresql_replica_database_engine_2/test.py::test_quoting_publication 0.96s call test_postgresql_replica_database_engine_2/test.py::test_quoting_publication =========================== short test summary info ============================ FAILED test_postgresql_replica_database_engine_2/test.py::test_quoting_publication ============================== 1 failed in 18.66s ============================== Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration/./runner", line 437, in subprocess.check_call(cmd, shell=True) File "/usr/lib/python3.10/subprocess.py", line 369, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command 'docker run --rm --name clickhouse_integration_tests_rydkld --privileged --dns-search='.' --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=2cffe1eae894 -e DOCKER_BASE_TAG=1d1c87eee2db -e DOCKER_KERBERIZED_HADOOP_TAG=ce74919e88f5 -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=a2d3dc777d0c -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS=" -rfEps --run-id=2 --color=no --durations=0 test_postgresql_replica_database_engine_2/test.py::test_quoting_publication -vvv" altinityinfra/integration-tests-runner:9d492c2eec24 ' returned non-zero exit status 1.